Visual Basic for Applications (VBA) is a programming language developed by Microsoft to automate tasks in MS Office applications. This book will help you to focus on the essential aspects of your role by automating mundane tasks in Excel and other Office applications. With comprehensive coverage of VBA delivered in the form of practice problems and bite-sized recipes, this book will help you to hit the ground running.Unlike most books that assume prior programming experience, this book starts with the fundamentals and gradually progresses to solving bigger problems.You’ll start by becoming familiar with VBA so that you can start recording macros right away. With this foundation in place, you’ll advance to using the full capabilities of the language as you apply loops, functions, and custom dialog boxes to design your own automation programs. You'll also get to grips with embedded macros and other advanced tools to enhance productivity and explore topics relating to app performance and security. Throughout this VBA book, you’ll cover multiple practice projects in Excel, Word, and PowerPoint while exploring tips and best practices to hone your skills.By the end of this book, you’ll have developed the skills you need to use VBA to create your own programs that control MS Office applications.

Automate Windows server tasks with the powerful features of the PowerShell LanguageKey Features* Leverage PowerShell to automate complex Windows server tasks * Master new features such as DevOps, and containers, and speed up their performance using PowerShell* Improve PowerShell's usability, and control and manage Windows-based environments by working through exciting recipesBook DescriptionWindows Server 2019 represents the latest version of Microsoft’s flagship server operating system. It also comes with PowerShell Version 5.1 and has a number of additional features that IT pros find useful.The book helps the reader learn how to use PowerShell and manage core roles, features, and services of Windows Server 2019.You will begin with creating a PowerShell Administrative Environment that has updated versions of PowerShell and the Windows Management Framework, updated versions of the .NET Framework, and third-party modules. Next, you will learn to use PowerShell to set up and configure Windows Server 2019 networking and also managing objects in the AD environment. You will also learn to set up a host to utilize containers and how to deploy containers. You will also be implementing different mechanisms for achieving desired state configuration along with getting well versed with Azure infrastructure and how to setup Virtual Machines, web sites, and shared files on Azure. Finally, you will be using some powerful tools you can use to diagnose and resolve issues with Windows Server 2019.By the end of the book, you will learn a lot of trips and tricks to automate your windows environment with PowerShellWhat you will learn* Perform key admin tasks on Windows Server 2019* Employing best practices for writing PowerShell scripts and configuring Windows Server 2019* Use the .NET Framework to achieve administrative scripting* Set up VMs, websites, and shared files on Azure* Report system performance using built-in cmdlets and WMI to obtain single measurements* Know the tools you can use to diagnose and resolve issues with Windows ServerWho this book is forIf you are a systems administrator, engineer, or an architect working with Windows Server 2016 interested in upgrading to Windows Server 2019 and automating tasks with PowerShell, then this book is for you. A basic knowledge of PowerShell is expected.

This book is for developers and system administrators who are responsible for hosting their application and managing instances in AWS. It’s also ideal for DevOps engineers looking to provide continuous integration, deployment, and delivery. A basic understanding of AWS, Jenkins, and some scripting knowledge is needed.

This book is for developers and system administrators who are responsible for hosting their application and managing instances in AWS. It’s also ideal for DevOps engineers looking to provide continuous integration, deployment, and delivery. A basic understanding of AWS, Jenkins, and some scripting knowledge is needed.

本书共包括8部分35章，分别介绍了Excel应用程序设计概述、VBA程序设计基础、Excel对象模型、用户界面设计、应用程序扩展、Excel应用程序的调试与优化等方面的内容，最后综合应用前面的知识设计了两个经典实例。本书知识全面，由浅入深，以相关代码讲解知识点，可使读者快速入门。适合需要用Excel解决复杂问题或者准备利用Excel VBA技术开发Excel应用程序的读者，也适合大中专院校的学生阅读，还可作为VBA培训教材。

本书共包括8部分35章，分别介绍了Excel应用程序设计概述、VBA程序设计基础、Excel对象模型、用户界面设计、应用程序扩展、Excel应用程序的调试与优化等方面的内容，最后综合应用前面的知识设计了两个经典实例。本书知识全面，由浅入深，以相关代码讲解知识点，可使读者快速入门。适合需要用Excel解决复杂问题或者准备利用Excel VBA技术开发Excel应用程序的读者，也适合大中专院校的学生阅读，还可作为VBA培训教材。

本书从应用与实用的角度出发，通过实例精讲的形式，详细介绍了Excel 2007 VBA在各种领域应用编程的各种方法、思路与问题处理技巧。本书共分17部分，主要内容包括：单元格选择技巧与选区统计、单元格数据处理技巧、条件格式及数据突现方式、排序、数据筛选、处理图形与艺术字、处理图表中的技巧、控制工作表、多工作表操作、工作表页面设置与打印、工作簿安全处理、文件与目录、窗体与控件、自定义函数、设制界面与菜单，以及两个综合实例。本书语言简洁，结构清晰，内容丰富，实战价值高。350个Excel 2007 VBA设计实例典型实用，覆盖面广，几乎包括了所有的Excel 2007 VBA知识点和应用技术；同时对实例的程序代码做了重点分析，提供了深入的程序设计思想，确保各实例具有通用性，利于读者举一反三。最后安排两个综合系统实例，对Excel 2007 VBA知识点进行了综合应用，帮助读者迅速提升VBA综合设计能力，实现从入门到精通的快速飞跃。本书光盘中包括所有实例的素材和程序源代码，读者稍加修改，便可应用于自己的工作中，物超所值。本书适合广大Excel VBA初、中级读者及VBA程序员使用，同时也可作为大中专院校相关专业学生，以及社会相关培训班学员的理想教材。

本书使用174个实例详细介绍了Excel VBA的语法内容。全书共分9章，分别介绍了VBA入门知识、VBA的语法基础、单元格对象操作、工作表对象操作、工作簿对象操作、数据处理和分析、图表对象操作、用户界面操作和自定义用户界面等内容。

本书从应用与实用的角度出发，通过实例精讲的形式，详细介绍了Excel 2007 VBA在各种领域应用编程的各种方法、思路与问题处理技巧。本书共分17部分，主要内容包括：单元格选择技巧与选区统计、单元格数据处理技巧、条件格式及数据突现方式、排序、数据筛选、处理图形与艺术字、处理图表中的技巧、控制工作表、多工作表操作、工作表页面设置与打印、工作簿安全处理、文件与目录、窗体与控件、自定义函数、设制界面与菜单，以及两个综合实例。本书语言简洁，结构清晰，内容丰富，实战价值高。350个Excel 2007 VBA设计实例典型实用，覆盖面广，几乎包括了所有的Excel 2007 VBA知识点和应用技术；同时对实例的程序代码做了重点分析，提供了深入的程序设计思想，确保各实例具有通用性，利于读者举一反三。最后安排两个综合系统实例，对Excel 2007 VBA知识点进行了综合应用，帮助读者迅速提升VBA综合设计能力，实现从入门到精通的快速飞跃。本书光盘中包括所有实例的素材和程序源代码，读者稍加修改，便可应用于自己的工作中，物超所值。本书适合广大Excel VBA初、中级读者及VBA程序员使用，同时也可作为大中专院校相关专业学生，以及社会相关培训班学员的理想教材。

本书使用174个实例详细介绍了Excel VBA的语法内容。全书共分9章，分别介绍了VBA入门知识、VBA的语法基础、单元格对象操作、工作表对象操作、工作簿对象操作、数据处理和分析、图表对象操作、用户界面操作和自定义用户界面等内容。